class CreatePeople < ActiveRecord::Migration
  def self.up
    create_table :people do |t|
      t.string :user, :null => false
      t.string :surname, :null => false
      t.string :firstname, :null => false
      t.string :gender, :null => false
      t.integer :age, :null => false
      t.integer :class_standing, :null => false, :options => "CONSTRAINT fk_person_class_standings REFERENCES class_standings(id)"
      t.integer :major, :null => false, :options => "CONSTRAINT fk_person_majors REFERENCES majors(id)"

      t.timestamps
    end
  end

  def self.down
    drop_table :people
  end
end
